How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Question Posted on 22 Sep 2023

Home >> DataBase >> MySQL MCQ >> How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Choose the correct option from below list
(1)UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
(2)UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
(3)MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
(4)MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

Answer:-(1)UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

With MySQL, how can you insert a new record into the "Persons" table?

Which MySQL statement is used to create a database table called "Customers"?

The NOT NULL constraint enforces a column to not accept NULL values.

With MySQL, how can you return the number of records in the "Persons" table?

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)